AW: Group by na FB

Otázka od: Burkovsky Ladislav

15. 11. 2002 16:16

ta hviezdicka bola myslena select Extract(month from datumfield), inyfield1
, inyfield2, ... from ... group by Extract(month from datumfield)

laco
-----Ursprüngliche Nachricht-----
Von: Lstiburek Pavel [mailto:Lstiburek@ceb.cz]
Gesendet: Freitag, 15. November 2002 13:15
An: 'delphi-l@clexpert.cz'
Betreff: RE: Group by na FB

SELECT * s GROUP BY ... nejde !

Pavel

-----Original Message-----
From: Burkovsky Ladislav [mailto:Ladislav.Burkovsky@autinform.de]
konferencia mam problem potreboval by som
Select * .. group by Extract(month from datumfield).
Zatial to robim cez View kde si urobim nove
fieldy a na tych to groupnem

Odpovedá: Karel Horky

15. 11. 2002 16:25

Burkovsky Ladislav, <mailto:Ladislav.Burkovsky@autinform.de> napsal:
BL> ta hviezdicka bola myslena select Extract(month from datumfield), inyfield1
BL> , inyfield2, ... from ... group by Extract(month from datumfield)

Zkus takto:
select Extract(month from datumfield) as MujMesic, inyfield1, inyfield2,
... from ... group by MujMesic

BL> -----Original Message-----
BL> From: Burkovsky Ladislav [mailto:Ladislav.Burkovsky@autinform.de]
BL> konferencia mam problem potreboval by som
BL> Select * .. group by Extract(month from datumfield).

------
S pozdravem Karel Horky
horky.karel@quick.cz
W2K/SP2, D5Ent/UP1